Tabela BeneficiaryAdditionalData

Definicja tabeli BeneficiaryAdditionalData

Name

BeneficiaryAdditionalData

Code

BeneficiaryAdditionalData

Comment

PL: Dodatkowe dane opisowe beneficjenta
EN: Additional descriptive beneficiary data


Lista kolumn tabeli BeneficiaryAdditionalData

Name

Code

LBenefitPlanContrBeneficiaryID

LBenefitPlanContrBeneficiaryID

EmployeeNo

EmployeeNo

InsurerNo

InsurerNo

PaySchema

PaySchema

InsurancePolicyNo

InsurancePolicyNo

InsurerClientNo

InsurerClientNo

DeclarationNo

DeclarationNo

InsurerName

InsurerName

InsurerKind

InsurerKind

EmployeePosition

EmployeePosition


Kolumna LBenefitPlanContrBeneficiaryID tabeli BeneficiaryAdditionalData

Definicja kolumny LBenefitPlanContrBeneficiaryID tabeli BeneficiaryAdditionalData

Name

LBenefitPlanContrBeneficiaryID

Code

LBenefitPlanContrBeneficiaryID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna EmployeeNo tabeli BeneficiaryAdditionalData

Definicja kolumny EmployeeNo tabeli BeneficiaryAdditionalData

Name

EmployeeNo

Code

EmployeeNo

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna InsurerNo tabeli BeneficiaryAdditionalData

Definicja kolumny InsurerNo tabeli BeneficiaryAdditionalData

Name

InsurerNo

Code

InsurerNo

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna PaySchema tabeli BeneficiaryAdditionalData

Definicja kolumny PaySchema tabeli BeneficiaryAdditionalData

Name

PaySchema

Code

PaySchema

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna InsurancePolicyNo tabeli BeneficiaryAdditionalData

Definicja kolumny InsurancePolicyNo tabeli BeneficiaryAdditionalData

Name

InsurancePolicyNo

Code

InsurancePolicyNo

Data Type

VARCHAR2(100)

Mandatory

No

Comment

 


Kolumna InsurerClientNo tabeli BeneficiaryAdditionalData

Definicja kolumny InsurerClientNo tabeli BeneficiaryAdditionalData

Name

InsurerClientNo

Code

InsurerClientNo

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna DeclarationNo tabeli BeneficiaryAdditionalData

Definicja kolumny DeclarationNo tabeli BeneficiaryAdditionalData

Name

DeclarationNo

Code

DeclarationNo

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna InsurerName tabeli BeneficiaryAdditionalData

Definicja kolumny InsurerName tabeli BeneficiaryAdditionalData

Name

InsurerName

Code

InsurerName

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna InsurerKind tabeli BeneficiaryAdditionalData

Definicja kolumny InsurerKind tabeli BeneficiaryAdditionalData

Name

InsurerKind

Code

InsurerKind

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna EmployeePosition tabeli BeneficiaryAdditionalData

Definicja kolumny EmployeePosition tabeli BeneficiaryAdditionalData

Name

EmployeePosition

Code

EmployeePosition

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Lista kluczy tabeli BeneficiaryAdditionalData

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli BeneficiaryAdditionalData

Definicja klucza Identifier_1 tabeli BeneficiaryAdditionalData

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment